Skip to main content

Table lock

Short Description

Table level lock

Detailed Description

MySQL uses table level locking for MyISAM, memory and merge tables. This allows access by only one session, making them more suitable for a read-only or single user application.

For information about table lock indicators, see Section 8.11.1, “Internal Locking Methods”.

How to reduce this wait

Not available yet. Contributions welcome.

MySQL Docs - Internal Locking Metods

Search online

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.